Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$COPY_CORRUPTION

This view displays information about datafile copy corruptions from the control file.

Column | Datatype | Description
--- | --- | ---
`RECID` | `NUMBER` | Copy corruption record ID
`STAMP` | `NUMBER` | Copy corruption record stamp
`COPY_RECID` | `NUMBER` | Datafile copy record ID
`COPY_STAMP` | `NUMBER` | Datafile copy record stamp
`FILE#` | `NUMBER` | Datafile number
`BLOCK#` | `NUMBER` | First block of the corrupted range
`BLOCKS` | `NUMBER` | Number of contiguous blocks in the corrupted range
`CORRUPTION_CHANGE#` | `NUMBER` | Change number at which the logical corruption was detected. Set to `0` to indicate media corruption.
`MARKED_CORRUPT` | `VARCHAR2(3)` | (`YES` | `NO`) If set to `YES` the blocks were not marked corrupted in the datafile, but were detected and marked as corrupted while making the datafile copy
`CORRUPTION_TYPE` | `VARCHAR2(9)` | Type of block corruption in the datafile: `ALL ZERO` - Block header on disk contained only zeros. The block may be valid if it was never filled and if it is in an Oracle7 file. The buffer will be reformatted to the Oracle8 standard for an empty block. `FRACTURED` - Block header looks reasonable, but the front and back of the block are different versions. `CHECKSUM` - optional check value shows that the block is not self-consistent. It is impossible to determine exactly why the check value fails, but it probably fails because sectors in the middle of the block are from different versions. `CORRUPT` - Block is wrongly identified or is not a data block (for example, the data block address is missing) `LOGICAL` - Specifies the range is for logically corrupt blocks. `CORRUPTION_CHANGE#` will have a nonzero value.